
<%@ page language="java" contentType="text/html; charset=GBK"%>
<%@ page import="com.database.DataBase" %>
<html>
  <head>
    <title>VipCardSubmit.jsp</title>
  </head>
  <body>
  <%
        String branchID=1+"";//request.getParameter("branchName");
        String vipID=request.getParameter("VipID");
        String CardLength=request.getParameter("CardLength");
        String CardVerifyStart=request.getParameter("CardVerifyStart");
        String CardVerifyEnd=request.getParameter("CardVerifyEnd");
        String CardVerifyData=new String(request.getParameter("CardVerifyData").toString().getBytes("ISO8859_1"));
        DataBase base=new DataBase();
        String sql="insert into vipcard(BranchID,VipID,CardLength,CardVerifyStart,CardVerifyEnd,CardVerifyData) values('"+branchID+"','"+vipID+"','"+CardLength+"','"+CardVerifyStart+"','"+CardVerifyEnd+"','"+CardVerifyData+"')";
        base.executeUpdate(sql);
        base.closeStmt();
        base.closeConn();
        response.sendRedirect("VipCardInsertSuccess.jsp?branchID="+branchID+"");
  %>
  </body>
</html>
